Skip to content

Microsoft Excel Expert

Self-paced with tutor support.

Pitman Training North London & Hertfordshire

Summary

Price
£399 inc VAT
Finance options

4, 6, 10 and 11 Month Interest Free Payment Plan Options Available/

Speak to one of our expert...

Study method
Online
Duration
22 hours · Self-paced
Access to content
Access until course completion
Qualification
No formal qualification
CPD
22 CPD hours / points
CPD What's this?
Certificates
  • Pitman Training Certification - Free
Additional info
  • Exam(s) / assessment(s) is included in price
  • Tutor is available to students
2 students enquired about this course

Add to basket or enquire

Overview

ABOUT THE COURSE
The course consists of 13 modules and includes media demonstrations, hands-on activities, and knowledge check questions. At the end of the course, you will complete a consolidation exercise, which will help you review what you have learned and assess your understanding. The course also contains quizzes at the end of each module and a Validation Test at the end of the course. With successful completion of the course, you will receive a Pitman Training certificate to verify your achievement.

AIMS AND OBJECTIVES
The aim of the course is to build on your knowledge and skills with the Excel 2019 application to gain advanced-level skills.

CPD

22 CPD hours / points
Accredited by The CPD Standards Office

Course media

Resources

  • Course Outline -

Description

COURSE CONTENT

Module 1: Using Functions
Using Functions; AutoSum

Module 2: Date and Time Functions
Basic and Complex Date and Time Functions

Module 3: Text Functions
Using Text Functions

Module 4: Logical Functions
Filling Cells by Using Flash Fill; Using Logical Functions

Module 5: Lookup Functions
CHOOSE, HLOOKUP, and VLOOKUP Functions

Module 6: Financial Functions
Financial Functions and Terminology; Personal and Professional Financial Functions; Depreciation

Module 7: Statistical Functions
Statistical Functions for Description, Forecasting, and Inference

Module 8: Connecting to External Data
Connecting to Other Workbooks, Access Databases, and Web Data Sources; Using Get and Transform Functions

Module 9: Macros
Recording and Managing Macros; Copying Macros between Workbooks

Module 10: Tables
Working with Tables; Table References; Table Styles

Module 11: PivotTables
Working with PivotTables; Filters and Slicers; PivotCharts

Module 12: Data Analysis
What-If Analysis; Scenario Manager; Using Goal Seek and the Solver Program

Module 13: Graphics and Charts
Area, Surface, Radar, and Bubble Charts; Sparklines; Stock Charts; Dual Axis and Other Charts

Who is this course for?

IS THIS COURSE FOR YOU?

This course is for those who are proficient with the basic and intermediate concepts and features of Excel and wish to build on their abilities with spreadsheets by leveraging Excel’s advanced features.

Requirements

PRE-REQUISITES

This course follows Excel 2019 - Beginner / Intermediate.

Career path

CAREER PATH

Microsoft Excel is used across a wide range of job roles. Your new skills with the software will make your work more efficient and more valuable to employers.

Possible Roles On Completion:

Executive Assistant: £30 - £35k

Data Analyst: £45 - £55k

Questions and answers

Certificates

Pitman Training Certification

Digital certificate - Included

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Microsoft 365 courses, Microsoft courses, Online courses